﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//
using AcctrueWMS.Foundation.Web.Session;
using AcctrueWMS.Foundation.DAL;

namespace AcctruePMS.Bll.Manager
{
    class ProjectFilterManager
    {
        //项目状态列表过滤(sys(#UserManager.Role()))
        public string projectStateListFilter()
        {
            string userNo, projectManager;
            userNo = System.Web.HttpContext.Current.Session[SessionConst.UserNo].ToString();
            projectManager = (string)WMSqlExcuter.ExecuteRealScalar(string.Format("select projectManager from project where createBy='{0}'", userNo));
            return "projectManager  ='" + projectManager + "'"; 
        }
    }
}
